Overview
Brought to you by YData
Dataset statistics
| Number of variables | 31 |
|---|---|
| Number of observations | 899164 |
| Missing cells | 1016326 |
| Missing cells (%) | 3.6% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 209.2 MiB |
| Average record size in memory | 244.0 B |
Variable types
| Numeric | 14 |
|---|---|
| Text | 5 |
| DateTime | 3 |
| Categorical | 7 |
| Boolean | 2 |
ApprovalFY is highly overall correlated with RetainedJob and 3 other fields | High correlation |
DisbursementGross is highly overall correlated with GrAppv and 2 other fields | High correlation |
GrAppv is highly overall correlated with DisbursementGross and 2 other fields | High correlation |
MIS_Status is highly overall correlated with has_chgoff_date | High correlation |
RetainedJob is highly overall correlated with ApprovalFY | High correlation |
RevLineCr is highly overall correlated with ApprovalFY and 2 other fields | High correlation |
SBA_Appv is highly overall correlated with DisbursementGross and 2 other fields | High correlation |
Term is highly overall correlated with DisbursementGross and 3 other fields | High correlation |
UrbanRural is highly overall correlated with ApprovalFY and 2 other fields | High correlation |
bool_RetainedJob is highly overall correlated with ApprovalFY and 2 other fields | High correlation |
has_chgoff_date is highly overall correlated with MIS_Status and 1 other fields | High correlation |
Recession is highly imbalanced (97.4%) | Imbalance |
RevLineCr has 277479 (30.9%) missing values | Missing |
ChgOffDate has 736465 (81.9%) missing values | Missing |
NoEmp is highly skewed (γ1 = 80.24824355) | Skewed |
CreateJob is highly skewed (γ1 = 36.99135473) | Skewed |
RetainedJob is highly skewed (γ1 = 36.85481184) | Skewed |
BalanceGross is highly skewed (γ1 = 601.1741483) | Skewed |
LoanNr_ChkDgt has unique values | Unique |
NAICS has 201948 (22.5%) zeros | Zeros |
CreateJob has 629248 (70.0%) zeros | Zeros |
RetainedJob has 440403 (49.0%) zeros | Zeros |
FranchiseCode has 208835 (23.2%) zeros | Zeros |
BalanceGross has 899150 (> 99.9%) zeros | Zeros |
ChgOffPrinGr has 737152 (82.0%) zeros | Zeros |
Reproduction
| Analysis started | 2025-02-13 10:01:57.385466 |
|---|---|
| Analysis finished | 2025-02-13 10:03:16.162326 |
| Duration | 1 minute and 18.78 seconds |
| Software version | ydata-profiling vv4.12.2 |
| Download configuration | config.json |
Variables
LoanNr_ChkDgt
Real number (ℝ)
Unique
| Distinct | 899164 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.7726123 × 109 |
| Minimum | 1.000014 × 109 |
|---|---|
| Maximum | 9.996003 × 109 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 1.000014 × 109 |
|---|---|
| 5-th percentile | 1.3484572 × 109 |
| Q1 | 2.5897575 × 109 |
| median | 4.361439 × 109 |
| Q3 | 6.9046265 × 109 |
| 95-th percentile | 9.1648039 × 109 |
| Maximum | 9.996003 × 109 |
| Range | 8.995989 × 109 |
| Interquartile range (IQR) | 4.314869 × 109 |
Descriptive statistics
| Standard deviation | 2.538175 × 109 |
|---|---|
| Coefficient of variation (CV) | 0.53182091 |
| Kurtosis | -1.086499 |
| Mean | 4.7726123 × 109 |
| Median Absolute Deviation (MAD) | 2.0134 × 109 |
| Skewness | 0.3647571 |
| Sum | 4.2913612 × 1015 |
| Variance | 6.4423325 × 1018 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1000014003 | 1 | < 0.1% |
| 5944984007 | 1 | < 0.1% |
| 5944874009 | 1 | < 0.1% |
| 5944884001 | 1 | < 0.1% |
| 5944904005 | 1 | < 0.1% |
| 5944914008 | 1 | < 0.1% |
| 5944924000 | 1 | < 0.1% |
| 5944934003 | 1 | < 0.1% |
| 5944944006 | 1 | < 0.1% |
| 5944954009 | 1 | < 0.1% |
| Other values (899154) | 899154 |
| Value | Count | Frequency (%) |
| 1000014003 | 1 | |
| 1000024006 | 1 | |
| 1000034009 | 1 | |
| 1000044001 | 1 | |
| 1000054004 | 1 | |
| 1000084002 | 1 | |
| 1000093009 | 1 | |
| 1000094005 | 1 | |
| 1000104006 | 1 | |
| 1000124001 | 1 |
| Value | Count | Frequency (%) |
| 9996003010 | 1 | |
| 9995973006 | 1 | |
| 9995613003 | 1 | |
| 9995603000 | 1 | |
| 9995573004 | 1 | |
| 9995563001 | 1 | |
| 9995493004 | 1 | |
| 9995473009 | 1 | |
| 9995453003 | 1 | |
| 9995423005 | 1 |
Name
Text
| Distinct | 779583 |
|---|---|
| Distinct (%) | 86.7% |
| Missing | 14 |
| Missing (%) | < 0.1% |
| Memory size | 6.9 MiB |
Length
| Max length | 30 |
|---|---|
| Median length | 23 |
| Mean length | 21.775963 |
| Min length | 1 |
Unique
| Unique | 706468 ? |
|---|---|
| Unique (%) | 78.6% |
Sample
| 1st row | ABC HOBBYCRAFT |
|---|---|
| 2nd row | LANDMARK BAR & GRILLE (THE) |
| 3rd row | WHITLOCK DDS, TODD M. |
| 4th row | BIG BUCKS PAWN & JEWELRY, LLC |
| 5th row | ANASTASIA CONFECTIONS, INC. |
| Value | Count | Frequency (%) |
| inc | 263379 | 8.4% |
| 100280 | 3.2% | |
| llc | 77826 | 2.5% |
| and | 28959 | 0.9% |
| the | 28389 | 0.9% |
| of | 23026 | 0.7% |
| dba | 20214 | 0.6% |
| co | 18216 | 0.6% |
| a | 18114 | 0.6% |
| services | 17318 | 0.6% |
| Other values (226643) | 2530176 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2231639 | 11.4% | |
| E | 1354056 | 6.9% |
| I | 1226719 | 6.3% |
| A | 1177821 | 6.0% |
| N | 1170319 | 6.0% |
| R | 1052562 | 5.4% |
| C | 1038114 | 5.3% |
| S | 1009495 | 5.2% |
| O | 933206 | 4.8% |
| T | 917437 | 4.7% |
| Other values (81) | 7468489 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 19579857 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2231639 | 11.4% | |
| E | 1354056 | 6.9% |
| I | 1226719 | 6.3% |
| A | 1177821 | 6.0% |
| N | 1170319 | 6.0% |
| R | 1052562 | 5.4% |
| C | 1038114 | 5.3% |
| S | 1009495 | 5.2% |
| O | 933206 | 4.8% |
| T | 917437 | 4.7% |
| Other values (81) | 7468489 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 19579857 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2231639 | 11.4% | |
| E | 1354056 | 6.9% |
| I | 1226719 | 6.3% |
| A | 1177821 | 6.0% |
| N | 1170319 | 6.0% |
| R | 1052562 | 5.4% |
| C | 1038114 | 5.3% |
| S | 1009495 | 5.2% |
| O | 933206 | 4.8% |
| T | 917437 | 4.7% |
| Other values (81) | 7468489 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 19579857 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2231639 | 11.4% | |
| E | 1354056 | 6.9% |
| I | 1226719 | 6.3% |
| A | 1177821 | 6.0% |
| N | 1170319 | 6.0% |
| R | 1052562 | 5.4% |
| C | 1038114 | 5.3% |
| S | 1009495 | 5.2% |
| O | 933206 | 4.8% |
| T | 917437 | 4.7% |
| Other values (81) | 7468489 |
City
Text
| Distinct | 32581 |
|---|---|
| Distinct (%) | 3.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.9 MiB |
Length
| Max length | 30 |
|---|---|
| Median length | 27 |
| Mean length | 9.1030491 |
| Min length | 1 |
Unique
| Unique | 12872 ? |
|---|---|
| Unique (%) | 1.4% |
Sample
| 1st row | EVANSVILLE |
|---|---|
| 2nd row | NEW PARIS |
| 3rd row | BLOOMINGTON |
| 4th row | BROKEN ARROW |
| 5th row | ORLANDO |
| Value | Count | Frequency (%) |
| city | 23834 | 2.0% |
| san | 21949 | 1.8% |
| new | 16076 | 1.3% |
| los | 13000 | 1.1% |
| angeles | 12380 | 1.0% |
| lake | 10730 | 0.9% |
| houston | 10587 | 0.9% |
| beach | 10462 | 0.9% |
| park | 10316 | 0.9% |
| york | 9724 | 0.8% |
| Other values (17695) | 1066619 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 744425 | 9.1% |
| E | 723116 | 8.8% |
| O | 632534 | 7.7% |
| N | 621363 | 7.6% |
| L | 573594 | 7.0% |
| R | 513616 | 6.3% |
| S | 475419 | 5.8% |
| I | 468368 | 5.7% |
| T | 425126 | 5.2% |
| 306954 | 3.8% | |
| Other values (70) | 2700619 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 8185134 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 744425 | 9.1% |
| E | 723116 | 8.8% |
| O | 632534 | 7.7% |
| N | 621363 | 7.6% |
| L | 573594 | 7.0% |
| R | 513616 | 6.3% |
| S | 475419 | 5.8% |
| I | 468368 | 5.7% |
| T | 425126 | 5.2% |
| 306954 | 3.8% | |
| Other values (70) | 2700619 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 8185134 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 744425 | 9.1% |
| E | 723116 | 8.8% |
| O | 632534 | 7.7% |
| N | 621363 | 7.6% |
| L | 573594 | 7.0% |
| R | 513616 | 6.3% |
| S | 475419 | 5.8% |
| I | 468368 | 5.7% |
| T | 425126 | 5.2% |
| 306954 | 3.8% | |
| Other values (70) | 2700619 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 8185134 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 744425 | 9.1% |
| E | 723116 | 8.8% |
| O | 632534 | 7.7% |
| N | 621363 | 7.6% |
| L | 573594 | 7.0% |
| R | 513616 | 6.3% |
| S | 475419 | 5.8% |
| I | 468368 | 5.7% |
| T | 425126 | 5.2% |
| 306954 | 3.8% | |
| Other values (70) | 2700619 |
State
Text
| Distinct | 51 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.9 MiB |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | IN |
|---|---|
| 2nd row | IN |
| 3rd row | IN |
| 4th row | OK |
| 5th row | FL |
| Value | Count | Frequency (%) |
| ca | 130622 | 14.5% |
| tx | 70462 | 7.8% |
| ny | 57693 | 6.4% |
| fl | 41213 | 4.6% |
| pa | 35170 | 3.9% |
| oh | 32622 | 3.6% |
| il | 29669 | 3.3% |
| ma | 25272 | 2.8% |
| mn | 24373 | 2.7% |
| nj | 24036 | 2.7% |
| Other values (41) | 428032 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 306179 | |
| C | 184960 | |
| N | 181728 | |
| M | 132550 | 7.4% |
| T | 125074 | 7.0% |
| I | 119520 | 6.6% |
| O | 94907 | 5.3% |
| L | 88820 | 4.9% |
| X | 70462 | 3.9% |
| Y | 68255 | 3.8% |
| Other values (14) | 425873 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1798328 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 306179 | |
| C | 184960 | |
| N | 181728 | |
| M | 132550 | 7.4% |
| T | 125074 | 7.0% |
| I | 119520 | 6.6% |
| O | 94907 | 5.3% |
| L | 88820 | 4.9% |
| X | 70462 | 3.9% |
| Y | 68255 | 3.8% |
| Other values (14) | 425873 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1798328 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 306179 | |
| C | 184960 | |
| N | 181728 | |
| M | 132550 | 7.4% |
| T | 125074 | 7.0% |
| I | 119520 | 6.6% |
| O | 94907 | 5.3% |
| L | 88820 | 4.9% |
| X | 70462 | 3.9% |
| Y | 68255 | 3.8% |
| Other values (14) | 425873 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1798328 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 306179 | |
| C | 184960 | |
| N | 181728 | |
| M | 132550 | 7.4% |
| T | 125074 | 7.0% |
| I | 119520 | 6.6% |
| O | 94907 | 5.3% |
| L | 88820 | 4.9% |
| X | 70462 | 3.9% |
| Y | 68255 | 3.8% |
| Other values (14) | 425873 |
Zip
Real number (ℝ)
| Distinct | 33611 |
|---|---|
| Distinct (%) | 3.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 53804.391 |
| Minimum | 0 |
|---|---|
| Maximum | 99999 |
| Zeros | 283 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3838 |
| Q1 | 27587 |
| median | 55410 |
| Q3 | 83704 |
| 95-th percentile | 95822 |
| Maximum | 99999 |
| Range | 99999 |
| Interquartile range (IQR) | 56117 |
Descriptive statistics
| Standard deviation | 31184.159 |
|---|---|
| Coefficient of variation (CV) | 0.5795839 |
| Kurtosis | -1.3359893 |
| Mean | 53804.391 |
| Median Absolute Deviation (MAD) | 28206 |
| Skewness | -0.16816663 |
| Sum | 4.8378972 × 1010 |
| Variance | 9.7245178 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10001 | 933 | 0.1% |
| 90015 | 926 | 0.1% |
| 93401 | 806 | 0.1% |
| 90010 | 733 | 0.1% |
| 33166 | 671 | 0.1% |
| 90021 | 666 | 0.1% |
| 59601 | 640 | 0.1% |
| 65804 | 599 | 0.1% |
| 3801 | 581 | 0.1% |
| 59101 | 578 | 0.1% |
| Other values (33601) | 892031 |
| Value | Count | Frequency (%) |
| 0 | 283 | |
| 1 | 24 | < 0.1% |
| 2 | 11 | < 0.1% |
| 3 | 5 | < 0.1% |
| 4 | 5 | < 0.1% |
| 5 | 5 | < 0.1% |
| 6 | 4 | < 0.1% |
| 7 | 6 | < 0.1% |
| 8 | 15 | < 0.1% |
| 9 | 24 | < 0.1% |
| Value | Count | Frequency (%) |
| 99999 | 209 | |
| 99950 | 3 | < 0.1% |
| 99929 | 15 | < 0.1% |
| 99928 | 1 | < 0.1% |
| 99926 | 1 | < 0.1% |
| 99925 | 4 | < 0.1% |
| 99923 | 1 | < 0.1% |
| 99921 | 13 | < 0.1% |
| 99919 | 2 | < 0.1% |
| 99918 | 1 | < 0.1% |
Bank
Text
| Distinct | 5803 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.9 MiB |
Length
| Max length | 30 |
|---|---|
| Median length | 26 |
| Mean length | 23.159879 |
| Min length | 3 |
Unique
| Unique | 923 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | FIFTH THIRD BANK |
|---|---|
| 2nd row | 1ST SOURCE BANK |
| 3rd row | GRANT COUNTY STATE BANK |
| 4th row | 1ST NATL BK & TR CO OF BROKEN |
| 5th row | FLORIDA BUS. DEVEL CORP |
| Value | Count | Frequency (%) |
| bank | 651608 | |
| natl | 318240 | 9.0% |
| assoc | 306768 | 8.7% |
| of | 142852 | 4.1% |
| national | 125899 | 3.6% |
| america | 100686 | 2.9% |
| association | 84965 | 2.4% |
| fargo | 63732 | 1.8% |
| wells | 63650 | 1.8% |
| 52264 | 1.5% | |
| Other values (3603) | 1608268 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 2762231 | |
| 2620014 | ||
| N | 2105500 | |
| S | 1520499 | 7.3% |
| O | 1336993 | 6.4% |
| T | 1181841 | 5.7% |
| C | 1134642 | 5.4% |
| I | 1061717 | 5.1% |
| E | 923739 | 4.4% |
| L | 922583 | 4.4% |
| Other values (44) | 5254770 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 20824529 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 2762231 | |
| 2620014 | ||
| N | 2105500 | |
| S | 1520499 | 7.3% |
| O | 1336993 | 6.4% |
| T | 1181841 | 5.7% |
| C | 1134642 | 5.4% |
| I | 1061717 | 5.1% |
| E | 923739 | 4.4% |
| L | 922583 | 4.4% |
| Other values (44) | 5254770 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 20824529 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 2762231 | |
| 2620014 | ||
| N | 2105500 | |
| S | 1520499 | 7.3% |
| O | 1336993 | 6.4% |
| T | 1181841 | 5.7% |
| C | 1134642 | 5.4% |
| I | 1061717 | 5.1% |
| E | 923739 | 4.4% |
| L | 922583 | 4.4% |
| Other values (44) | 5254770 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 20824529 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 2762231 | |
| 2620014 | ||
| N | 2105500 | |
| S | 1520499 | 7.3% |
| O | 1336993 | 6.4% |
| T | 1181841 | 5.7% |
| C | 1134642 | 5.4% |
| I | 1061717 | 5.1% |
| E | 923739 | 4.4% |
| L | 922583 | 4.4% |
| Other values (44) | 5254770 |
BankState
Text
| Distinct | 56 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.9 MiB |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | OH |
|---|---|
| 2nd row | IN |
| 3rd row | IN |
| 4th row | OK |
| 5th row | FL |
| Value | Count | Frequency (%) |
| ca | 118255 | 13.2% |
| nc | 79526 | 8.8% |
| il | 66006 | 7.3% |
| oh | 58498 | 6.5% |
| sd | 51105 | 5.7% |
| tx | 48069 | 5.3% |
| ri | 45385 | 5.0% |
| ny | 39661 | 4.4% |
| va | 29007 | 3.2% |
| de | 24541 | 2.7% |
| Other values (46) | 339111 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 241894 | |
| C | 229804 | |
| N | 187930 | |
| I | 159224 | 8.9% |
| O | 102724 | 5.7% |
| L | 97096 | 5.4% |
| D | 96248 | 5.4% |
| T | 95265 | 5.3% |
| M | 85204 | 4.7% |
| S | 73429 | 4.1% |
| Other values (14) | 429510 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1798328 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 241894 | |
| C | 229804 | |
| N | 187930 | |
| I | 159224 | 8.9% |
| O | 102724 | 5.7% |
| L | 97096 | 5.4% |
| D | 96248 | 5.4% |
| T | 95265 | 5.3% |
| M | 85204 | 4.7% |
| S | 73429 | 4.1% |
| Other values (14) | 429510 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1798328 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 241894 | |
| C | 229804 | |
| N | 187930 | |
| I | 159224 | 8.9% |
| O | 102724 | 5.7% |
| L | 97096 | 5.4% |
| D | 96248 | 5.4% |
| T | 95265 | 5.3% |
| M | 85204 | 4.7% |
| S | 73429 | 4.1% |
| Other values (14) | 429510 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1798328 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 241894 | |
| C | 229804 | |
| N | 187930 | |
| I | 159224 | 8.9% |
| O | 102724 | 5.7% |
| L | 97096 | 5.4% |
| D | 96248 | 5.4% |
| T | 95265 | 5.3% |
| M | 85204 | 4.7% |
| S | 73429 | 4.1% |
| Other values (14) | 429510 |
NAICS
Real number (ℝ)
Zeros
| Distinct | 25 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 39.612263 |
| Minimum | 0 |
|---|---|
| Maximum | 92 |
| Zeros | 201948 |
| Zeros (%) | 22.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 23 |
| median | 44 |
| Q3 | 56 |
| 95-th percentile | 81 |
| Maximum | 92 |
| Range | 92 |
| Interquartile range (IQR) | 33 |
Descriptive statistics
| Standard deviation | 26.284706 |
|---|---|
| Coefficient of variation (CV) | 0.66354972 |
| Kurtosis | -1.0572678 |
| Mean | 39.612263 |
| Median Absolute Deviation (MAD) | 18 |
| Skewness | -0.24819754 |
| Sum | 35617921 |
| Variance | 690.88577 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=25)
| Value | Count | Frequency (%) |
| 0 | 201948 | |
| 44 | 84737 | |
| 81 | 72618 | 8.1% |
| 54 | 68170 | 7.6% |
| 72 | 67600 | 7.5% |
| 23 | 66646 | 7.4% |
| 62 | 55366 | 6.2% |
| 42 | 48743 | 5.4% |
| 45 | 42514 | 4.7% |
| 33 | 38284 | 4.3% |
| Other values (15) | 152538 |
| Value | Count | Frequency (%) |
| 0 | 201948 | |
| 11 | 9005 | 1.0% |
| 21 | 1851 | 0.2% |
| 22 | 663 | 0.1% |
| 23 | 66646 | 7.4% |
| 31 | 11809 | 1.3% |
| 32 | 17936 | 2.0% |
| 33 | 38284 | 4.3% |
| 42 | 48743 | 5.4% |
| 44 | 84737 |
| Value | Count | Frequency (%) |
| 92 | 229 | < 0.1% |
| 81 | 72618 | |
| 72 | 67600 | |
| 71 | 14640 | 1.6% |
| 62 | 55366 | |
| 61 | 6425 | 0.7% |
| 56 | 32685 | |
| 55 | 257 | < 0.1% |
| 54 | 68170 | |
| 53 | 13632 | 1.5% |
ApprovalDate
Date
| Distinct | 9859 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.9 MiB |
| Minimum | 1961-12-07 00:00:00 |
|---|---|
| Maximum | 2014-06-25 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
ApprovalFY
Real number (ℝ)
High correlation
| Distinct | 51 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2001.1436 |
| Minimum | 1962 |
|---|---|
| Maximum | 2014 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 1962 |
|---|---|
| 5-th percentile | 1991 |
| Q1 | 1997 |
| median | 2002 |
| Q3 | 2006 |
| 95-th percentile | 2009 |
| Maximum | 2014 |
| Range | 52 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 5.9138459 |
|---|---|
| Coefficient of variation (CV) | 0.0029552332 |
| Kurtosis | -0.092531047 |
| Mean | 2001.1436 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -0.58537855 |
| Sum | 1.7993562 × 109 |
| Variance | 34.973573 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2005 | 77525 | 8.6% |
| 2006 | 76040 | 8.5% |
| 2007 | 71876 | 8.0% |
| 2004 | 68290 | 7.6% |
| 2003 | 58193 | 6.5% |
| 1995 | 45758 | 5.1% |
| 2002 | 44391 | 4.9% |
| 1996 | 40112 | 4.5% |
| 2008 | 39540 | 4.4% |
| 1997 | 37748 | 4.2% |
| Other values (41) | 339691 |
| Value | Count | Frequency (%) |
| 1962 | 1 | < 0.1% |
| 1965 | 1 | < 0.1% |
| 1966 | 1 | < 0.1% |
| 1967 | 2 | < 0.1% |
| 1968 | 2 | < 0.1% |
| 1969 | 4 | < 0.1% |
| 1970 | 8 | < 0.1% |
| 1971 | 20 | < 0.1% |
| 1972 | 27 | |
| 1973 | 52 |
| Value | Count | Frequency (%) |
| 2014 | 268 | < 0.1% |
| 2013 | 2458 | 0.3% |
| 2012 | 5997 | 0.7% |
| 2011 | 12608 | 1.4% |
| 2010 | 16848 | 1.9% |
| 2009 | 19126 | 2.1% |
| 2008 | 39540 | |
| 2007 | 71876 | |
| 2006 | 76040 | |
| 2005 | 77525 |
Term
Real number (ℝ)
High correlation
| Distinct | 412 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 110.77308 |
| Minimum | 0 |
|---|---|
| Maximum | 569 |
| Zeros | 810 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 16 |
| Q1 | 60 |
| median | 84 |
| Q3 | 120 |
| 95-th percentile | 300 |
| Maximum | 569 |
| Range | 569 |
| Interquartile range (IQR) | 60 |
Descriptive statistics
| Standard deviation | 78.857305 |
|---|---|
| Coefficient of variation (CV) | 0.7118815 |
| Kurtosis | 0.18570424 |
| Mean | 110.77308 |
| Median Absolute Deviation (MAD) | 33 |
| Skewness | 1.1209258 |
| Sum | 99603164 |
| Variance | 6218.4746 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 84 | 230162 | |
| 60 | 89945 | 10.0% |
| 240 | 85982 | 9.6% |
| 120 | 77654 | 8.6% |
| 300 | 44727 | 5.0% |
| 180 | 28164 | 3.1% |
| 36 | 19800 | 2.2% |
| 12 | 17095 | 1.9% |
| 48 | 15621 | 1.7% |
| 72 | 9419 | 1.0% |
| Other values (402) | 280595 |
| Value | Count | Frequency (%) |
| 0 | 810 | 0.1% |
| 1 | 1608 | |
| 2 | 1809 | |
| 3 | 2112 | |
| 4 | 2173 | |
| 5 | 1866 | |
| 6 | 3054 | |
| 7 | 1761 | |
| 8 | 1693 | |
| 9 | 1875 |
| Value | Count | Frequency (%) |
| 569 | 1 | |
| 527 | 1 | |
| 511 | 1 | |
| 505 | 1 | |
| 481 | 1 | |
| 480 | 1 | |
| 461 | 1 | |
| 449 | 1 | |
| 445 | 1 | |
| 443 | 1 |
NoEmp
Real number (ℝ)
Skewed
| Distinct | 599 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.411353 |
| Minimum | 0 |
|---|---|
| Maximum | 9999 |
| Zeros | 6631 |
| Zeros (%) | 0.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 10 |
| 95-th percentile | 40 |
| Maximum | 9999 |
| Range | 9999 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 74.108196 |
|---|---|
| Coefficient of variation (CV) | 6.4942514 |
| Kurtosis | 7965.2886 |
| Mean | 11.411353 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 80.248244 |
| Sum | 10260678 |
| Variance | 5492.0248 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 154254 | |
| 2 | 138297 | |
| 3 | 90674 | |
| 4 | 73644 | 8.2% |
| 5 | 60319 | 6.7% |
| 6 | 45759 | 5.1% |
| 10 | 31536 | 3.5% |
| 7 | 31495 | 3.5% |
| 8 | 31361 | 3.5% |
| 12 | 20822 | 2.3% |
| Other values (589) | 221003 |
| Value | Count | Frequency (%) |
| 0 | 6631 | 0.7% |
| 1 | 154254 | |
| 2 | 138297 | |
| 3 | 90674 | |
| 4 | 73644 | |
| 5 | 60319 | 6.7% |
| 6 | 45759 | 5.1% |
| 7 | 31495 | 3.5% |
| 8 | 31361 | 3.5% |
| 9 | 18131 | 2.0% |
| Value | Count | Frequency (%) |
| 9999 | 4 | |
| 9992 | 1 | < 0.1% |
| 9945 | 1 | < 0.1% |
| 9090 | 1 | < 0.1% |
| 9000 | 2 | < 0.1% |
| 8500 | 1 | < 0.1% |
| 8041 | 1 | < 0.1% |
| 8018 | 1 | < 0.1% |
| 8000 | 7 | |
| 7999 | 1 | < 0.1% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 645005 | |
| 0.0 | 254159 | 28.3% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 645005 | |
| 0.0 | 254159 | 28.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1153323 | |
| . | 899164 | |
| 1 | 645005 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2697492 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1153323 | |
| . | 899164 | |
| 1 | 645005 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2697492 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1153323 | |
| . | 899164 | |
| 1 | 645005 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2697492 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1153323 | |
| . | 899164 | |
| 1 | 645005 |
CreateJob
Real number (ℝ)
Skewed Zeros
| Distinct | 246 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.4303764 |
| Minimum | 0 |
|---|---|
| Maximum | 8800 |
| Zeros | 629248 |
| Zeros (%) | 70.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 10 |
| Maximum | 8800 |
| Range | 8800 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 236.68817 |
|---|---|
| Coefficient of variation (CV) | 28.075634 |
| Kurtosis | 1369.911 |
| Mean | 8.4303764 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 36.991355 |
| Sum | 7580291 |
| Variance | 56021.288 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 629248 | |
| 1 | 63174 | 7.0% |
| 2 | 57831 | 6.4% |
| 3 | 28806 | 3.2% |
| 4 | 20511 | 2.3% |
| 5 | 18691 | 2.1% |
| 10 | 11602 | 1.3% |
| 6 | 11009 | 1.2% |
| 8 | 7378 | 0.8% |
| 7 | 6374 | 0.7% |
| Other values (236) | 44540 | 5.0% |
| Value | Count | Frequency (%) |
| 0 | 629248 | |
| 1 | 63174 | 7.0% |
| 2 | 57831 | 6.4% |
| 3 | 28806 | 3.2% |
| 4 | 20511 | 2.3% |
| 5 | 18691 | 2.1% |
| 6 | 11009 | 1.2% |
| 7 | 6374 | 0.7% |
| 8 | 7378 | 0.8% |
| 9 | 3330 | 0.4% |
| Value | Count | Frequency (%) |
| 8800 | 648 | |
| 5621 | 1 | < 0.1% |
| 5199 | 1 | < 0.1% |
| 5085 | 1 | < 0.1% |
| 3500 | 1 | < 0.1% |
| 3100 | 1 | < 0.1% |
| 3000 | 4 | < 0.1% |
| 2515 | 1 | < 0.1% |
| 2140 | 1 | < 0.1% |
| 2020 | 1 | < 0.1% |
RetainedJob
Real number (ℝ)
High correlation Skewed Zeros
| Distinct | 358 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.797257 |
| Minimum | 0 |
|---|---|
| Maximum | 9500 |
| Zeros | 440403 |
| Zeros (%) | 49.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 4 |
| 95-th percentile | 20 |
| Maximum | 9500 |
| Range | 9500 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 237.1206 |
|---|---|
| Coefficient of variation (CV) | 21.961188 |
| Kurtosis | 1362.0182 |
| Mean | 10.797257 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 36.854812 |
| Sum | 9708505 |
| Variance | 56226.179 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 440403 | |
| 1 | 88790 | 9.9% |
| 2 | 76851 | 8.5% |
| 3 | 49963 | 5.6% |
| 4 | 39666 | 4.4% |
| 5 | 32627 | 3.6% |
| 6 | 23796 | 2.6% |
| 7 | 16530 | 1.8% |
| 8 | 15698 | 1.7% |
| 10 | 15438 | 1.7% |
| Other values (348) | 99402 | 11.1% |
| Value | Count | Frequency (%) |
| 0 | 440403 | |
| 1 | 88790 | 9.9% |
| 2 | 76851 | 8.5% |
| 3 | 49963 | 5.6% |
| 4 | 39666 | 4.4% |
| 5 | 32627 | 3.6% |
| 6 | 23796 | 2.6% |
| 7 | 16530 | 1.8% |
| 8 | 15698 | 1.7% |
| 9 | 8735 | 1.0% |
| Value | Count | Frequency (%) |
| 9500 | 1 | < 0.1% |
| 8800 | 648 | |
| 7250 | 1 | < 0.1% |
| 5000 | 1 | < 0.1% |
| 4441 | 1 | < 0.1% |
| 4000 | 2 | < 0.1% |
| 3900 | 1 | < 0.1% |
| 3860 | 1 | < 0.1% |
| 3225 | 1 | < 0.1% |
| 3200 | 1 | < 0.1% |
FranchiseCode
Real number (ℝ)
Zeros
| Distinct | 2768 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2753.7259 |
| Minimum | 0 |
|---|---|
| Maximum | 99999 |
| Zeros | 208835 |
| Zeros (%) | 23.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 15805 |
| Maximum | 99999 |
| Range | 99999 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 12758.019 |
|---|---|
| Coefficient of variation (CV) | 4.6330025 |
| Kurtosis | 24.409524 |
| Mean | 2753.7259 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.9752152 |
| Sum | 2.4760512 × 109 |
| Variance | 1.6276705 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 638554 | |
| 0 | 208835 | 23.2% |
| 78760 | 3373 | 0.4% |
| 68020 | 1921 | 0.2% |
| 50564 | 1034 | 0.1% |
| 21780 | 1003 | 0.1% |
| 25650 | 715 | 0.1% |
| 79140 | 659 | 0.1% |
| 22470 | 615 | 0.1% |
| 17998 | 606 | 0.1% |
| Other values (2758) | 41849 | 4.7% |
| Value | Count | Frequency (%) |
| 0 | 208835 | 23.2% |
| 1 | 638554 | |
| 3 | 12 | < 0.1% |
| 395 | 5 | < 0.1% |
| 399 | 3 | < 0.1% |
| 400 | 2 | < 0.1% |
| 401 | 12 | < 0.1% |
| 404 | 1 | < 0.1% |
| 407 | 34 | < 0.1% |
| 414 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 99999 | 1 | < 0.1% |
| 92006 | 4 | < 0.1% |
| 92000 | 9 | |
| 91999 | 11 | |
| 91450 | 2 | < 0.1% |
| 91446 | 1 | < 0.1% |
| 91443 | 2 | < 0.1% |
| 91435 | 1 | < 0.1% |
| 91424 | 1 | < 0.1% |
| 91423 | 2 | < 0.1% |
UrbanRural
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.9 MiB |
| 1 | |
|---|---|
| 0 | |
| 2 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 470654 | |
| 0 | 323167 | |
| 2 | 105343 | 11.7% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 470654 | |
| 0 | 323167 | |
| 2 | 105343 | 11.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 470654 | |
| 0 | 323167 | |
| 2 | 105343 | 11.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 899164 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 470654 | |
| 0 | 323167 | |
| 2 | 105343 | 11.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 899164 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 470654 | |
| 0 | 323167 | |
| 2 | 105343 | 11.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 899164 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 470654 | |
| 0 | 323167 | |
| 2 | 105343 | 11.7% |
RevLineCr
Boolean
High correlation Missing
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 277479 |
| Missing (%) | 30.9% |
| Memory size | 1.7 MiB |
| False | |
|---|---|
| True | |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 420288 | |
| True | 201397 | |
| (Missing) | 277479 |
| Value | Count | Frequency (%) |
| False | 785252 | |
| True | 113912 | 12.7% |
ChgOffDate
Date
Missing
| Distinct | 6448 |
|---|---|
| Distinct (%) | 4.0% |
| Missing | 736465 |
| Missing (%) | 81.9% |
| Memory size | 6.9 MiB |
| Minimum | 1988-10-03 00:00:00 |
|---|---|
| Maximum | 2026-10-22 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
DisbursementDate
Date
| Distinct | 8472 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 2368 |
| Missing (%) | 0.3% |
| Memory size | 6.9 MiB |
| Minimum | 1975-01-17 00:00:00 |
|---|---|
| Maximum | 2074-12-04 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
DisbursementGross
Real number (ℝ)
High correlation
| Distinct | 118859 |
|---|---|
| Distinct (%) | 13.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 201154.02 |
| Minimum | 0 |
|---|---|
| Maximum | 11446325 |
| Zeros | 196 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 10000 |
| Q1 | 42000 |
| median | 100000 |
| Q3 | 238000 |
| 95-th percentile | 761892.5 |
| Maximum | 11446325 |
| Range | 11446325 |
| Interquartile range (IQR) | 196000 |
Descriptive statistics
| Standard deviation | 287640.85 |
|---|---|
| Coefficient of variation (CV) | 1.4299533 |
| Kurtosis | 35.088599 |
| Mean | 201154.02 |
| Median Absolute Deviation (MAD) | 70000 |
| Skewness | 3.9409921 |
| Sum | 1.8087045 × 1011 |
| Variance | 8.2737259 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 50000 | 43787 | 4.9% |
| 100000 | 36714 | 4.1% |
| 25000 | 27387 | 3.0% |
| 150000 | 23373 | 2.6% |
| 10000 | 21328 | 2.4% |
| 35000 | 14748 | 1.6% |
| 5000 | 14193 | 1.6% |
| 75000 | 13528 | 1.5% |
| 20000 | 13462 | 1.5% |
| 30000 | 12696 | 1.4% |
| Other values (118849) | 677948 |
| Value | Count | Frequency (%) |
| 0 | 196 | |
| 1 | 11 | < 0.1% |
| 2 | 3 | < 0.1% |
| 3 | 3 | < 0.1% |
| 4 | 3 | < 0.1% |
| 5 | 2 | < 0.1% |
| 6 | 4 | < 0.1% |
| 7 | 3 | < 0.1% |
| 8 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 11446325 | 1 | |
| 11000000 | 1 | |
| 10465000 | 1 | |
| 9284449 | 1 | |
| 8995000 | 1 | |
| 8607858 | 1 | |
| 8602584 | 1 | |
| 7853275 | 1 | |
| 7699233 | 1 | |
| 7573881 | 1 |
BalanceGross
Real number (ℝ)
Skewed Zeros
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.989349 |
| Minimum | 0 |
|---|---|
| Maximum | 996262 |
| Zeros | 899150 |
| Zeros (%) | > 99.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 996262 |
| Range | 996262 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1442.1619 |
|---|---|
| Coefficient of variation (CV) | 482.43344 |
| Kurtosis | 380418.84 |
| Mean | 2.989349 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 601.17415 |
| Sum | 2687915 |
| Variance | 2079831 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=15)
| Value | Count | Frequency (%) |
| 0 | 899150 | |
| 12750 | 1 | < 0.1% |
| 827875 | 1 | < 0.1% |
| 25000 | 1 | < 0.1% |
| 37100 | 1 | < 0.1% |
| 43127 | 1 | < 0.1% |
| 84617 | 1 | < 0.1% |
| 1760 | 1 | < 0.1% |
| 115820 | 1 | < 0.1% |
| 996262 | 1 | < 0.1% |
| Other values (5) | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 899150 | |
| 600 | 1 | < 0.1% |
| 1760 | 1 | < 0.1% |
| 9111 | 1 | < 0.1% |
| 12750 | 1 | < 0.1% |
| 25000 | 1 | < 0.1% |
| 37100 | 1 | < 0.1% |
| 41509 | 1 | < 0.1% |
| 43127 | 1 | < 0.1% |
| 84617 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 996262 | 1 | |
| 827875 | 1 | |
| 395476 | 1 | |
| 115820 | 1 | |
| 96908 | 1 | |
| 84617 | 1 | |
| 43127 | 1 | |
| 41509 | 1 | |
| 37100 | 1 | |
| 25000 | 1 |
MIS_Status
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.9 MiB |
| P I F | |
|---|---|
| CHGOFF |
Length
| Max length | 6 |
|---|---|
| Median length | 5 |
| Mean length | 5.1755175 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | P I F |
|---|---|
| 2nd row | P I F |
| 3rd row | P I F |
| 4th row | P I F |
| 5th row | P I F |
Common Values
| Value | Count | Frequency (%) |
| P I F | 741345 | |
| CHGOFF | 157819 | 17.6% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| p | 741345 | |
| i | 741345 | |
| f | 741345 | |
| chgoff | 157819 | 6.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1482690 | ||
| F | 1056983 | |
| P | 741345 | |
| I | 741345 | |
| C | 157819 | 3.4% |
| H | 157819 | 3.4% |
| G | 157819 | 3.4% |
| O | 157819 | 3.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4653639 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1482690 | ||
| F | 1056983 | |
| P | 741345 | |
| I | 741345 | |
| C | 157819 | 3.4% |
| H | 157819 | 3.4% |
| G | 157819 | 3.4% |
| O | 157819 | 3.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4653639 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1482690 | ||
| F | 1056983 | |
| P | 741345 | |
| I | 741345 | |
| C | 157819 | 3.4% |
| H | 157819 | 3.4% |
| G | 157819 | 3.4% |
| O | 157819 | 3.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4653639 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1482690 | ||
| F | 1056983 | |
| P | 741345 | |
| I | 741345 | |
| C | 157819 | 3.4% |
| H | 157819 | 3.4% |
| G | 157819 | 3.4% |
| O | 157819 | 3.4% |
ChgOffPrinGr
Real number (ℝ)
Zeros
| Distinct | 83165 |
|---|---|
| Distinct (%) | 9.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13503.295 |
| Minimum | 0 |
|---|---|
| Maximum | 3512596 |
| Zeros | 737152 |
| Zeros (%) | 82.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 64888.85 |
| Maximum | 3512596 |
| Range | 3512596 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 65152.293 |
|---|---|
| Coefficient of variation (CV) | 4.8249181 |
| Kurtosis | 184.31916 |
| Mean | 13503.295 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 11.22097 |
| Sum | 1.2141677 × 1010 |
| Variance | 4.2448212 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 737152 | |
| 50000 | 2110 | 0.2% |
| 10000 | 1865 | 0.2% |
| 25000 | 1371 | 0.2% |
| 35000 | 1345 | 0.1% |
| 100000 | 1028 | 0.1% |
| 20000 | 594 | 0.1% |
| 30000 | 492 | 0.1% |
| 15000 | 467 | 0.1% |
| 5000 | 356 | < 0.1% |
| Other values (83155) | 152384 | 16.9% |
| Value | Count | Frequency (%) |
| 0 | 737152 | |
| 1 | 6 | < 0.1% |
| 3 | 3 | < 0.1% |
| 4 | 2 | < 0.1% |
| 5 | 5 | < 0.1% |
| 6 | 3 | < 0.1% |
| 8 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
| 10 | 1 | < 0.1% |
| 11 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 3512596 | 1 | |
| 2223766 | 1 | |
| 2157499 | 1 | |
| 1999999 | 1 | |
| 1961398 | 1 | |
| 1933715 | 1 | |
| 1932180 | 1 | |
| 1931439 | 1 | |
| 1926148 | 1 | |
| 1917676 | 1 |
GrAppv
Real number (ℝ)
High correlation
| Distinct | 22128 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 192686.98 |
| Minimum | 200 |
|---|---|
| Maximum | 5472000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 200 |
|---|---|
| 5-th percentile | 10000 |
| Q1 | 35000 |
| median | 90000 |
| Q3 | 225000 |
| 95-th percentile | 750000 |
| Maximum | 5472000 |
| Range | 5471800 |
| Interquartile range (IQR) | 190000 |
Descriptive statistics
| Standard deviation | 283263.39 |
|---|---|
| Coefficient of variation (CV) | 1.4700702 |
| Kurtosis | 21.018882 |
| Mean | 192686.98 |
| Median Absolute Deviation (MAD) | 65000 |
| Skewness | 3.5207901 |
| Sum | 1.7325719 × 1011 |
| Variance | 8.0238149 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 50000 | 69394 | 7.7% |
| 25000 | 51258 | 5.7% |
| 100000 | 50977 | 5.7% |
| 10000 | 38366 | 4.3% |
| 150000 | 27624 | 3.1% |
| 20000 | 23434 | 2.6% |
| 35000 | 23181 | 2.6% |
| 30000 | 21004 | 2.3% |
| 5000 | 19146 | 2.1% |
| 15000 | 18472 | 2.1% |
| Other values (22118) | 556308 |
| Value | Count | Frequency (%) |
| 200 | 2 | < 0.1% |
| 300 | 1 | < 0.1% |
| 400 | 2 | < 0.1% |
| 500 | 33 | < 0.1% |
| 700 | 4 | < 0.1% |
| 800 | 4 | < 0.1% |
| 950 | 1 | < 0.1% |
| 1000 | 444 | |
| 1200 | 12 | < 0.1% |
| 1300 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 5472000 | 1 | < 0.1% |
| 5000000 | 40 | |
| 4991700 | 1 | < 0.1% |
| 4950000 | 1 | < 0.1% |
| 4908500 | 1 | < 0.1% |
| 4900000 | 2 | < 0.1% |
| 4872000 | 1 | < 0.1% |
| 4869000 | 1 | < 0.1% |
| 4830000 | 1 | < 0.1% |
| 4800000 | 1 | < 0.1% |
SBA_Appv
Real number (ℝ)
High correlation
| Distinct | 38326 |
|---|---|
| Distinct (%) | 4.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 149488.79 |
| Minimum | 100 |
|---|---|
| Maximum | 5472000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 100 |
|---|---|
| 5-th percentile | 5000 |
| Q1 | 21250 |
| median | 61250 |
| Q3 | 175000 |
| 95-th percentile | 626250 |
| Maximum | 5472000 |
| Range | 5471900 |
| Interquartile range (IQR) | 153750 |
Descriptive statistics
| Standard deviation | 228414.56 |
|---|---|
| Coefficient of variation (CV) | 1.5279712 |
| Kurtosis | 25.325514 |
| Mean | 149488.79 |
| Median Absolute Deviation (MAD) | 48750 |
| Skewness | 3.6752753 |
| Sum | 1.3441494 × 1011 |
| Variance | 5.2173212 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 25000 | 49579 | 5.5% |
| 12500 | 40147 | 4.5% |
| 5000 | 31135 | 3.5% |
| 50000 | 25047 | 2.8% |
| 10000 | 17009 | 1.9% |
| 17500 | 16141 | 1.8% |
| 15000 | 14490 | 1.6% |
| 7500 | 12781 | 1.4% |
| 127500 | 11946 | 1.3% |
| 80000 | 10965 | 1.2% |
| Other values (38316) | 669924 |
| Value | Count | Frequency (%) |
| 100 | 2 | < 0.1% |
| 150 | 1 | < 0.1% |
| 200 | 2 | < 0.1% |
| 250 | 33 | < 0.1% |
| 350 | 4 | < 0.1% |
| 400 | 4 | < 0.1% |
| 475 | 1 | < 0.1% |
| 500 | 442 | |
| 600 | 12 | < 0.1% |
| 650 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 5472000 | 1 | < 0.1% |
| 5000000 | 1 | < 0.1% |
| 4869000 | 1 | < 0.1% |
| 4582000 | 1 | < 0.1% |
| 4500000 | 23 | |
| 4492530 | 1 | < 0.1% |
| 4410000 | 1 | < 0.1% |
| 4320000 | 1 | < 0.1% |
| 4050000 | 4 | < 0.1% |
| 4000000 | 13 |
has_chgoff_date
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.9 MiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 736465 | |
| 1 | 162699 | 18.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 736465 | |
| 1 | 162699 | 18.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 736465 | |
| 1 | 162699 | 18.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 899164 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 736465 | |
| 1 | 162699 | 18.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 899164 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 736465 | |
| 1 | 162699 | 18.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 899164 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 736465 | |
| 1 | 162699 | 18.1% |
bool_RetainedJob
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.9 MiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 458761 | |
| 0 | 440403 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 458761 | |
| 0 | 440403 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 458761 | |
| 0 | 440403 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 899164 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 458761 | |
| 0 | 440403 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 899164 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 458761 | |
| 0 | 440403 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 899164 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 458761 | |
| 0 | 440403 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 629248 | |
| 1 | 269916 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 629248 | |
| 1 | 269916 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 629248 | |
| 1 | 269916 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 899164 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 629248 | |
| 1 | 269916 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 899164 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 629248 | |
| 1 | 269916 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 899164 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 629248 | |
| 1 | 269916 |
Recession
Categorical
Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.9 MiB |
| 1 | |
|---|---|
| 0 | 2368 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 896796 | |
| 0 | 2368 | 0.3% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 896796 | |
| 0 | 2368 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 896796 | |
| 0 | 2368 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 899164 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 896796 | |
| 0 | 2368 | 0.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 899164 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 896796 | |
| 0 | 2368 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 899164 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 896796 | |
| 0 | 2368 | 0.3% |
Interactions
Correlations
| ApprovalFY | BalanceGross | ChgOffPrinGr | CreateJob | DisbursementGross | FranchiseCode | GrAppv | LoanNr_ChkDgt | LowDoc | MIS_Status | NAICS | NewExist | NoEmp | Recession | RetainedJob | RevLineCr | SBA_Appv | Term | UrbanRural | Zip | bool_CreateJob | bool_RetainedJob | has_chgoff_date | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ApprovalFY | 1.000 | 0.003 | 0.251 | 0.268 | -0.222 | -0.452 | -0.300 | -0.278 | 0.363 | 0.327 | 0.440 | 0.053 | -0.226 | 0.069 | 0.546 | 0.545 | -0.366 | -0.297 | 0.659 | -0.038 | 0.320 | 0.653 | 0.334 |
| BalanceGross | 0.003 | 1.000 | -0.002 | 0.003 | 0.002 | 0.001 | 0.001 | 0.001 | 0.000 | 0.000 | 0.003 | 0.002 | -0.000 | 0.000 | 0.000 | 0.000 | 0.001 | -0.000 | 0.002 | -0.000 | 0.001 | 0.000 | 0.000 |
| ChgOffPrinGr | 0.251 | -0.002 | 1.000 | 0.055 | -0.127 | -0.206 | -0.161 | -0.184 | 0.032 | 0.181 | 0.092 | 0.006 | -0.106 | 0.000 | 0.156 | 0.047 | -0.180 | -0.404 | 0.019 | -0.005 | 0.008 | 0.015 | 0.178 |
| CreateJob | 0.268 | 0.003 | 0.055 | 1.000 | 0.110 | -0.054 | 0.093 | -0.031 | 0.010 | 0.012 | 0.156 | 0.002 | 0.034 | 0.000 | 0.377 | 0.022 | 0.078 | 0.082 | 0.025 | 0.026 | 0.042 | 0.026 | 0.012 |
| DisbursementGross | -0.222 | 0.002 | -0.127 | 0.110 | 1.000 | 0.204 | 0.965 | 0.102 | 0.052 | 0.031 | -0.120 | 0.021 | 0.445 | 0.002 | -0.070 | 0.041 | 0.936 | 0.521 | 0.040 | 0.115 | 0.035 | 0.015 | 0.032 |
| FranchiseCode | -0.452 | 0.001 | -0.206 | -0.054 | 0.204 | 1.000 | 0.259 | 0.392 | 0.035 | 0.022 | -0.085 | 0.139 | 0.121 | 0.005 | -0.263 | 0.091 | 0.285 | 0.196 | 0.013 | 0.031 | 0.035 | 0.062 | 0.024 |
| GrAppv | -0.300 | 0.001 | -0.161 | 0.093 | 0.965 | 0.259 | 1.000 | 0.139 | 0.118 | 0.074 | -0.142 | 0.049 | 0.455 | 0.010 | -0.138 | 0.172 | 0.986 | 0.558 | 0.051 | 0.119 | 0.058 | 0.063 | 0.077 |
| LoanNr_ChkDgt | -0.278 | 0.001 | -0.184 | -0.031 | 0.102 | 0.392 | 0.139 | 1.000 | 0.240 | 0.237 | -0.047 | 0.085 | 0.075 | 0.027 | -0.142 | 0.229 | 0.169 | 0.121 | 0.189 | 0.031 | 0.130 | 0.238 | 0.240 |
| LowDoc | 0.363 | 0.000 | 0.032 | 0.010 | 0.052 | 0.035 | 0.118 | 0.240 | 1.000 | 0.077 | 0.147 | 0.164 | 0.003 | 0.015 | 0.010 | 0.218 | 0.099 | 0.171 | 0.206 | 0.145 | 0.235 | 0.370 | 0.079 |
| MIS_Status | 0.327 | 0.000 | 0.181 | 0.012 | 0.031 | 0.022 | 0.074 | 0.237 | 0.077 | 1.000 | 0.148 | 0.019 | 0.004 | 0.000 | 0.013 | 0.130 | 0.070 | 0.491 | 0.210 | 0.080 | 0.074 | 0.204 | 0.981 |
| NAICS | 0.440 | 0.003 | 0.092 | 0.156 | -0.120 | -0.085 | -0.142 | -0.047 | 0.147 | 0.148 | 1.000 | 0.132 | -0.151 | 0.013 | 0.268 | 0.383 | -0.169 | -0.076 | 0.432 | -0.033 | 0.207 | 0.431 | 0.151 |
| NewExist | 0.053 | 0.002 | 0.006 | 0.002 | 0.021 | 0.139 | 0.049 | 0.085 | 0.164 | 0.019 | 0.132 | 1.000 | 0.003 | 0.000 | 0.003 | 0.093 | 0.040 | 0.122 | 0.041 | 0.122 | 0.043 | 0.110 | 0.020 |
| NoEmp | -0.226 | -0.000 | -0.106 | 0.034 | 0.445 | 0.121 | 0.455 | 0.075 | 0.003 | 0.004 | -0.151 | 0.003 | 1.000 | 0.000 | 0.124 | 0.009 | 0.449 | 0.200 | 0.010 | 0.059 | 0.005 | 0.012 | 0.004 |
| Recession | 0.069 | 0.000 | 0.000 | 0.000 | 0.002 | 0.005 | 0.010 | 0.027 | 0.015 | 0.000 | 0.013 | 0.000 | 0.000 | 1.000 | 0.000 | 0.055 | 0.009 | 0.027 | 0.019 | 0.010 | 0.007 | 0.023 | 0.000 |
| RetainedJob | 0.546 | 0.000 | 0.156 | 0.377 | -0.070 | -0.263 | -0.138 | -0.142 | 0.010 | 0.013 | 0.268 | 0.003 | 0.124 | 0.000 | 1.000 | 0.022 | -0.205 | -0.157 | 0.025 | -0.026 | 0.041 | 0.027 | 0.012 |
| RevLineCr | 0.545 | 0.000 | 0.047 | 0.022 | 0.041 | 0.091 | 0.172 | 0.229 | 0.218 | 0.130 | 0.383 | 0.093 | 0.009 | 0.055 | 0.022 | 1.000 | 0.145 | 0.456 | 0.533 | 0.167 | 0.138 | 0.551 | 0.131 |
| SBA_Appv | -0.366 | 0.001 | -0.180 | 0.078 | 0.936 | 0.285 | 0.986 | 0.169 | 0.099 | 0.070 | -0.169 | 0.040 | 0.449 | 0.009 | -0.205 | 0.145 | 1.000 | 0.589 | 0.051 | 0.131 | 0.091 | 0.045 | 0.073 |
| Term | -0.297 | -0.000 | -0.404 | 0.082 | 0.521 | 0.196 | 0.558 | 0.121 | 0.171 | 0.491 | -0.076 | 0.122 | 0.200 | 0.027 | -0.157 | 0.456 | 0.589 | 1.000 | 0.207 | 0.142 | 0.259 | 0.271 | 0.504 |
| UrbanRural | 0.659 | 0.002 | 0.019 | 0.025 | 0.040 | 0.013 | 0.051 | 0.189 | 0.206 | 0.210 | 0.432 | 0.041 | 0.010 | 0.019 | 0.025 | 0.533 | 0.051 | 0.207 | 1.000 | 0.126 | 0.303 | 0.626 | 0.213 |
| Zip | -0.038 | -0.000 | -0.005 | 0.026 | 0.115 | 0.031 | 0.119 | 0.031 | 0.145 | 0.080 | -0.033 | 0.122 | 0.059 | 0.010 | -0.026 | 0.167 | 0.131 | 0.142 | 0.126 | 1.000 | 0.072 | 0.144 | 0.084 |
| bool_CreateJob | 0.320 | 0.001 | 0.008 | 0.042 | 0.035 | 0.035 | 0.058 | 0.130 | 0.235 | 0.074 | 0.207 | 0.043 | 0.005 | 0.007 | 0.041 | 0.138 | 0.091 | 0.259 | 0.303 | 0.072 | 1.000 | 0.384 | 0.077 |
| bool_RetainedJob | 0.653 | 0.000 | 0.015 | 0.026 | 0.015 | 0.062 | 0.063 | 0.238 | 0.370 | 0.204 | 0.431 | 0.110 | 0.012 | 0.023 | 0.027 | 0.551 | 0.045 | 0.271 | 0.626 | 0.144 | 0.384 | 1.000 | 0.209 |
| has_chgoff_date | 0.334 | 0.000 | 0.178 | 0.012 | 0.032 | 0.024 | 0.077 | 0.240 | 0.079 | 0.981 | 0.151 | 0.020 | 0.004 | 0.000 | 0.012 | 0.131 | 0.073 | 0.504 | 0.213 | 0.084 | 0.077 | 0.209 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| LoanNr_ChkDgt | Name | City | State | Zip | Bank | BankState | NAICS | ApprovalDate | ApprovalFY | Term | NoEmp | NewExist | CreateJob | RetainedJob | FranchiseCode | UrbanRural | RevLineCr | LowDoc | ChgOffDate | DisbursementDate | DisbursementGross | BalanceGross | MIS_Status | ChgOffPrinGr | GrAppv | SBA_Appv | has_chgoff_date | bool_RetainedJob | bool_CreateJob | Recession | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1000014003 | ABC HOBBYCRAFT | EVANSVILLE | IN | 47711 | FIFTH THIRD BANK | OH | 45 | 1997-02-28 | 1997 | 84 | 4 | 0.0 | 0 | 0 | 1 | 0 | N | Y | NaT | 1999-02-28 | 60000.0 | 0.0 | P I F | 0.0 | 60000.0 | 48000.0 | 0 | 0 | 0 | 1 |
| 1 | 1000024006 | LANDMARK BAR & GRILLE (THE) | NEW PARIS | IN | 46526 | 1ST SOURCE BANK | IN | 72 | 1997-02-28 | 1997 | 60 | 2 | 0.0 | 0 | 0 | 1 | 0 | N | Y | NaT | 1997-05-31 | 40000.0 | 0.0 | P I F | 0.0 | 40000.0 | 32000.0 | 0 | 0 | 0 | 1 |
| 2 | 1000034009 | WHITLOCK DDS, TODD M. | BLOOMINGTON | IN | 47401 | GRANT COUNTY STATE BANK | IN | 62 | 1997-02-28 | 1997 | 180 | 7 | 1.0 | 0 | 0 | 1 | 0 | N | N | NaT | 1997-12-31 | 287000.0 | 0.0 | P I F | 0.0 | 287000.0 | 215250.0 | 0 | 0 | 0 | 1 |
| 3 | 1000044001 | BIG BUCKS PAWN & JEWELRY, LLC | BROKEN ARROW | OK | 74012 | 1ST NATL BK & TR CO OF BROKEN | OK | 0 | 1997-02-28 | 1997 | 60 | 2 | 1.0 | 0 | 0 | 1 | 0 | N | Y | NaT | 1997-06-30 | 35000.0 | 0.0 | P I F | 0.0 | 35000.0 | 28000.0 | 0 | 0 | 0 | 1 |
| 4 | 1000054004 | ANASTASIA CONFECTIONS, INC. | ORLANDO | FL | 32801 | FLORIDA BUS. DEVEL CORP | FL | 0 | 1997-02-28 | 1997 | 240 | 14 | 1.0 | 7 | 7 | 1 | 0 | N | N | NaT | 1997-05-14 | 229000.0 | 0.0 | P I F | 0.0 | 229000.0 | 229000.0 | 0 | 1 | 1 | 1 |
| 5 | 1000084002 | B&T SCREW MACHINE COMPANY, INC | PLAINVILLE | CT | 6062 | TD BANK, NATIONAL ASSOCIATION | DE | 33 | 1997-02-28 | 1997 | 120 | 19 | 1.0 | 0 | 0 | 1 | 0 | N | N | NaT | 1997-06-30 | 517000.0 | 0.0 | P I F | 0.0 | 517000.0 | 387750.0 | 0 | 0 | 0 | 1 |
| 6 | 1000093009 | MIDDLE ATLANTIC SPORTS CO INC | UNION | NJ | 7083 | WELLS FARGO BANK NATL ASSOC | SD | 0 | 1980-06-02 | 1980 | 45 | 45 | 0.0 | 0 | 0 | 0 | 0 | N | N | 1991-06-24 | 1980-07-22 | 600000.0 | 0.0 | CHGOFF | 208959.0 | 600000.0 | 499998.0 | 1 | 0 | 0 | 1 |
| 7 | 1000094005 | WEAVER PRODUCTS | SUMMERFIELD | FL | 34491 | REGIONS BANK | AL | 81 | 1997-02-28 | 1997 | 84 | 1 | 0.0 | 0 | 0 | 1 | 0 | N | Y | NaT | 1998-06-30 | 45000.0 | 0.0 | P I F | 0.0 | 45000.0 | 36000.0 | 0 | 0 | 0 | 1 |
| 8 | 1000104006 | TURTLE BEACH INN | PORT SAINT JOE | FL | 32456 | CENTENNIAL BANK | FL | 72 | 1997-02-28 | 1997 | 297 | 2 | 0.0 | 0 | 0 | 1 | 0 | N | N | NaT | 1997-07-31 | 305000.0 | 0.0 | P I F | 0.0 | 305000.0 | 228750.0 | 0 | 0 | 0 | 1 |
| 9 | 1000124001 | INTEXT BUILDING SYS LLC | GLASTONBURY | CT | 6073 | WEBSTER BANK NATL ASSOC | CT | 0 | 1997-02-28 | 1997 | 84 | 3 | 0.0 | 0 | 0 | 1 | 0 | N | Y | NaT | 1997-04-30 | 70000.0 | 0.0 | P I F | 0.0 | 70000.0 | 56000.0 | 0 | 0 | 0 | 1 |
| LoanNr_ChkDgt | Name | City | State | Zip | Bank | BankState | NAICS | ApprovalDate | ApprovalFY | Term | NoEmp | NewExist | CreateJob | RetainedJob | FranchiseCode | UrbanRural | RevLineCr | LowDoc | ChgOffDate | DisbursementDate | DisbursementGross | BalanceGross | MIS_Status | ChgOffPrinGr | GrAppv | SBA_Appv | has_chgoff_date | bool_RetainedJob | bool_CreateJob | Recession | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 899154 | 9995423005 | LITWIN LIVERY SERVICES, INC. | CAMPBELL | OH | 44405 | JPMORGAN CHASE BANK NATL ASSOC | IL | 0 | 1997-02-27 | 1997 | 60 | 1 | 1.0 | 0 | 0 | 1 | 0 | NaN | N | NaT | 1997-09-30 | 10000.0 | 0.0 | P I F | 0.0 | 10000.0 | 5000.0 | 0 | 0 | 0 | 1 |
| 899155 | 9995453003 | FUTURE LEADERS CENTER, INC. | SO. OZONE PARK | NY | 11420 | FLUSHING BANK | NY | 62 | 1997-02-27 | 1997 | 180 | 2 | 1.0 | 0 | 0 | 1 | 0 | NaN | N | NaT | 1997-06-30 | 123000.0 | 0.0 | P I F | 0.0 | 128000.0 | 96000.0 | 0 | 0 | 0 | 1 |
| 899156 | 9995473009 | FABRICATORS STEEL, INC. | BALTIMORE | MD | 21224 | BANK OF AMERICA NATL ASSOC | MD | 33 | 1997-02-27 | 1997 | 60 | 20 | 1.0 | 0 | 0 | 1 | 0 | NaN | N | NaT | 1997-06-30 | 50000.0 | 0.0 | P I F | 0.0 | 50000.0 | 25000.0 | 0 | 0 | 0 | 1 |
| 899157 | 9995493004 | PULLTARPS MFG. | EL CAJON | CA | 92020 | U.S. BANK NATIONAL ASSOCIATION | CA | 31 | 1997-02-27 | 1997 | 36 | 40 | 1.0 | 0 | 0 | 1 | 0 | N | N | NaT | 1997-03-31 | 200000.0 | 0.0 | P I F | 0.0 | 200000.0 | 150000.0 | 0 | 0 | 0 | 1 |
| 899158 | 9995563001 | SHADES WINDOW TINTING AUTO ALA | IRVING | TX | 75062 | LOANS FROM OLD CLOSED LENDERS | DC | 0 | 1997-02-27 | 1997 | 84 | 5 | 0.0 | 0 | 0 | 1 | 0 | N | Y | NaT | 1997-06-30 | 79000.0 | 0.0 | P I F | 0.0 | 79000.0 | 63200.0 | 0 | 0 | 0 | 1 |
| 899159 | 9995573004 | FABRIC FARMS | UPPER ARLINGTON | OH | 43221 | JPMORGAN CHASE BANK NATL ASSOC | IL | 45 | 1997-02-27 | 1997 | 60 | 6 | 1.0 | 0 | 0 | 1 | 0 | NaN | N | NaT | 1997-09-30 | 70000.0 | 0.0 | P I F | 0.0 | 70000.0 | 56000.0 | 0 | 0 | 0 | 1 |
| 899160 | 9995603000 | FABRIC FARMS | COLUMBUS | OH | 43221 | JPMORGAN CHASE BANK NATL ASSOC | IL | 45 | 1997-02-27 | 1997 | 60 | 6 | 1.0 | 0 | 0 | 1 | 0 | Y | N | NaT | 1997-10-31 | 85000.0 | 0.0 | P I F | 0.0 | 85000.0 | 42500.0 | 0 | 0 | 0 | 1 |
| 899161 | 9995613003 | RADCO MANUFACTURING CO.,INC. | SANTA MARIA | CA | 93455 | RABOBANK, NATIONAL ASSOCIATION | CA | 33 | 1997-02-27 | 1997 | 108 | 26 | 1.0 | 0 | 0 | 1 | 0 | N | N | NaT | 1997-09-30 | 300000.0 | 0.0 | P I F | 0.0 | 300000.0 | 225000.0 | 0 | 0 | 0 | 1 |
| 899162 | 9995973006 | MARUTAMA HAWAII, INC. | HONOLULU | HI | 96830 | BANK OF HAWAII | HI | 0 | 1997-02-27 | 1997 | 60 | 6 | 1.0 | 0 | 0 | 1 | 0 | N | Y | 2000-03-08 | 1997-03-31 | 75000.0 | 0.0 | CHGOFF | 46383.0 | 75000.0 | 60000.0 | 1 | 0 | 0 | 1 |
| 899163 | 9996003010 | PACIFIC TRADEWINDS FAN & LIGHT | KAILUA | HI | 96734 | CENTRAL PACIFIC BANK | HI | 0 | 1997-02-27 | 1997 | 48 | 1 | 0.0 | 0 | 0 | 1 | 0 | N | N | NaT | 1997-05-31 | 30000.0 | 0.0 | P I F | 0.0 | 30000.0 | 24000.0 | 0 | 0 | 0 | 1 |